<?php
/*******************************************************************************
 *  This file is part of mysql-proxy.
 *
 *  mysql-proxy is free software: you can redistribute it and/or modify
 *  it under the terms of the GNU General Public License as published by
 *  the Free Software Foundation, either version 3 of the License, or
 *  (at your option) any later version.
 *
 *  mysql-proxy is distributed in the hope that it will be useful,
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *  GNU General Public License for more details.
 *
 *  You should have received a copy of the GNU General Public License
 *  along with this program.  If not, see <http://www.gnu.org/licenses/>.
 *******************************************************************************
 * Author: Lidanyang  <simonarthur2012@gmail.com>
 ******************************************************************************/

$dsn = 'mysql:host=127.0.0.1;port=9536;dbname=Test';
$user = '';
$password = '';

try {
    $dbh = new PDO($dsn, $user, $password);
    $statement = $dbh->query("show tables");
    var_dump($statement->fetchAll(\PDO::FETCH_ASSOC));

//    $statement = $dbh->query("select * from Test");
//    var_dump($statement->fetchAll(\PDO::FETCH_ASSOC));
} catch (PDOException $e) {
    echo 'Connection failed: ' . $e->getMessage();
}